翻訳と辞書 |
Bitemporal data : ウィキペディア英語版 | Bitemporal data
In a temporal database, bitemporal data is both the valid time and transaction time of the data. In a database table bitemporal data is often represented by four extra table-columns StartVT and EndVT, StartTT and EndTT. Normally each time interval is closed at its lower bound, and open at its upper bound. ==Bitemporal Table== A bitemporal table〔(【引用サイトリンク】url=http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.admin.dbobj.doc/doc/c0058481.html )〕 is a table that combines the historical tracking of a system-period temporal table (transaction time table) with the time-specific data storage capabilities of an application-period temporal table (valid time table). Bitemporal tables are used to keep user-based period information as well as system-based historical information. Bitemporal tables behave as a combination of system-period temporal tables and application-period temporal tables. All the restrictions that apply to system-period temporal tables and application temporal tables also apply to bitemporal tables.
抄文引用元・出典: フリー百科事典『 ウィキペディア(Wikipedia)』 ■ウィキペディアで「Bitemporal data」の詳細全文を読む
スポンサード リンク
翻訳と辞書 : 翻訳のためのインターネットリソース |
Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.
|
|